Finding ID | Version | Rule ID | IA Controls | Severity |
---|---|---|---|---|
V-2593 | DO3696-ORACLE11 | SV-24942r2_rule | Medium |
Description |
---|
The Oracle RESOURCE_LIMIT parameter determines whether resource limits are enforced in database profiles. If Oracle resource limits are disabled, any defined profile limits will be ignored. NOTE: This does not apply to password resources. |
STIG | Date |
---|---|
Oracle Database 11g Instance STIG | 2016-12-14 |
Check Text ( C-29487r2_chk ) |
---|
From SQL*Plus: select value from v$parameter where name = 'resource_limit'; If the value returned is not set to TRUE, this is a Finding. |
Fix Text (F-26553r1_fix) |
---|
Enable resource limit checking on the database. From SQL*Plus: alter system set resource_limit = TRUE scope = both; The above SQL*Plus command will set the parameter to take effect immediately and permanently at next system startup. |